{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "ERROR:lml.utils:failed to import pyecharts_snapshot\n",
      "Traceback (most recent call last):\n",
      "  File \"/home/loong/anaconda3/lib/python3.7/site-packages/lml/utils.py\", line 43, in do_import\n",
      "    plugin_module = __import__(plugin_module_name)\n",
      "ModuleNotFoundError: No module named 'pyecharts_snapshot'\n"
     ]
    }
   ],
   "source": [
    "import pymysql\n",
    "import csv\n",
    "import pandas as  pd\n",
    "import matplotlib.pylab as pyl\n",
    "import numpy as np\n",
    "from pyecharts import Bar, Grid, Line\n",
    "# 导入绘图包\n",
    "#coding:utf-8\n",
    "import matplotlib.pyplot as plt\n",
    "plt.rcParams['font.sans-serif']=['SimHei'] # 用来正常显示中文标签\n",
    "plt.rcParams['axes.unicode_minus']=False # 用来正常显示负号"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "#将表写入\n",
    "# db = pymysql.connect(\"106.12.30.33\",\"ykq\",\"mbsb74194741\",\"finance\",charset=\"utf8\")\n",
    "# cursor = db.cursor()\n",
    "# sqlInsert = (\"SELECT  * FROM   zhanglong \")\n",
    "#print(sqlInsert)\n",
    "# try:\n",
    "# cursor.execute(sqlInsert)\n",
    "# db.commit()\n",
    "# data = cursor.fetchall()\n",
    "# with open(\"gupiao5.csv\",\"w+\",encoding=\"utf-8_sig\") as f:\n",
    "#     w = csv.writer(f)\n",
    "#     cname = [\"股票编号\",\"股票名称\",\"最新价\",\"涨跌额\",\"涨跌幅\",\"今开\",\"最高\",\"最低\",\"昨收\",\"今交\",\"成交额\"]\n",
    "#     w = csv.DictWriter(f,cname)\n",
    "#     w.writeheader()\n",
    "#     for i in data:\n",
    "#         #print(i)\n",
    "#         w.writerow(\n",
    "#         {\n",
    "#             \"股票编号\":i[1],\n",
    "#             \"股票名称\":i[2],\n",
    "#             \"最新价\":i[3],\n",
    "#             \"涨跌额\":i[4],\n",
    "#             \"涨跌幅\":i[5],\n",
    "#             \"今开\":i[6],\n",
    "#             \"最高\":i[7],\n",
    "#             \"最低\":i[8],\n",
    "#             \"昨收\":i[9],\n",
    "#             \"今交\":i[10],\n",
    "#             \"成交额\":i[11],\n",
    "#         }\n",
    "#             )\n",
    "# # except:\n",
    "#     db.rollback()\n",
    "#     print(\"NO\", cursor.rowcount)\n",
    "# db.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#数据清洗\n",
    "db1 = pd.read_csv(\"gupiao1.csv\")\n",
    "a1 = db1.drop_duplicates(\"成交额\")\n",
    "a1 = a1.drop([0])\n",
    "db2 = pd.read_csv(\"gupiao2.csv\")\n",
    "a2 = db2.drop_duplicates(\"成交额\")\n",
    "a2 = a2.drop([0])\n",
    "db3 = pd.read_csv(\"gupiao3.csv\")\n",
    "a3 = db3.drop_duplicates(\"成交额\")\n",
    "a3 = a3.drop([0])\n",
    "db4 = pd.read_csv(\"gupiao4.csv\")\n",
    "a4 = db4.drop_duplicates(\"成交额\")\n",
    "a4 = a4.drop([0])\n",
    "db5 = pd.read_csv(\"gupiao5.csv\")\n",
    "a5 = db5.drop_duplicates(\"成交额\")\n",
    "a5 = a5.drop([0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "请输入股票名称腾讯控股\n"
     ]
    }
   ],
   "source": [
    "#df1=pd.pivot_table(a1[a1[\"股票名称\"]==\"腾讯控股\"],values=[\"价格\"],index=[\"出发地\"],columns=[\"目的地\"])\n",
    "name1 = input(\"请输入股票名称\")\n",
    "b1 = a1[a1[\"股票名称\"]== name1]\n",
    "b2 =a2[a2[\"股票名称\"]== name1]\n",
    "b3 =a3[a3[\"股票名称\"]== name1]\n",
    "b4 =a4[a4[\"股票名称\"]== name1]\n",
    "b5 =a5[a5[\"股票名称\"]== name1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"6d9eebf7d4364699b69d078fcd537f82\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_6d9eebf7d4364699b69d078fcd537f82 = echarts.init(document.getElementById('6d9eebf7d4364699b69d078fcd537f82'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_6d9eebf7d4364699b69d078fcd537f82 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u6298\\u7ebf\\u56fe\",\n",
       "            \"subtext\": \"\\u80a1\\u7968\\u8fd1\\u4e94\\u5929\\u7684\\u60c5\\u51b5\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2321024,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"line\",\n",
       "            \"name\": \"\\u6da8\\u8dcc\\u989d\",\n",
       "            \"symbol\": \"emptyCircle\",\n",
       "            \"symbolSize\": 4,\n",
       "            \"smooth\": false,\n",
       "            \"step\": false,\n",
       "            \"showSymbol\": true,\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e00\",\n",
       "                    [\n",
       "                        -0.4\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e8c\",\n",
       "                    [\n",
       "                        -1.0\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e09\",\n",
       "                    [\n",
       "                        7.2\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u56db\",\n",
       "                    [\n",
       "                        7.2\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e94\",\n",
       "                    [\n",
       "                        7.2\n",
       "                    ]\n",
       "                ]\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2321024\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"line\",\n",
       "            \"name\": \"\\u6700\\u65b0\\u4ef7\",\n",
       "            \"symbol\": \"emptyCircle\",\n",
       "            \"symbolSize\": 4,\n",
       "            \"smooth\": false,\n",
       "            \"step\": false,\n",
       "            \"showSymbol\": true,\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e00\",\n",
       "                    [\n",
       "                        375.2\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e8c\",\n",
       "                    [\n",
       "                        376.8\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e09\",\n",
       "                    [\n",
       "                        384.0\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u56db\",\n",
       "                    [\n",
       "                        384.0\n",
       "                    ]\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u661f\\u671f\\u4e94\",\n",
       "                    [\n",
       "                        384.0\n",
       "                    ]\n",
       "                ]\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2321024\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u6da8\\u8dcc\\u989d\",\n",
       "                \"\\u6700\\u65b0\\u4ef7\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u661f\\u671f\\u4e00\",\n",
       "                \"\\u661f\\u671f\\u4e8c\",\n",
       "                \"\\u661f\\u671f\\u4e09\",\n",
       "                \"\\u661f\\u671f\\u56db\",\n",
       "                \"\\u661f\\u671f\\u4e94\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_6d9eebf7d4364699b69d078fcd537f82.setOption(option_6d9eebf7d4364699b69d078fcd537f82);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.line.Line at 0x7f7d4c4ab5d0>"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "line = Line(\"折线图\",\"股票近五天的情况\")\n",
    "c1 = b1[\"涨跌额\"]\n",
    "c2 = b2[\"涨跌额\"]\n",
    "c3= b3[\"涨跌额\"]\n",
    "c4 = b4[\"涨跌额\"]\n",
    "c5 = b5[\"涨跌额\"]\n",
    "d1 = b1[\"最新价\"]\n",
    "d2 = b2[\"最新价\"]\n",
    "d3= b3[\"最新价\"]\n",
    "d4 = b4[\"最新价\"]\n",
    "d5 = b5[\"最新价\"]\n",
    "#is_label_show是设置上方数据是否显示\n",
    "columns =[\"星期一\",\"星期二\",\"星期三\",\"星期四\",\"星期五\",]\n",
    "data1=[c1,c2,c3,c4,c5]\n",
    "data2=[d1,d2,d3,d4,d5]\n",
    "line.add(\"涨跌额\", columns, data1, is_label_show=True)\n",
    "line.add(\"最新价\", columns, data2, is_label_show=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "腾讯控股\n",
      "阿里巴巴-SW\n",
      "中国移动\n",
      "中国平安\n",
      "友邦保险\n",
      "建设银行\n",
      "美团点评-W\n",
      "香港交易所\n",
      "舜宇光学科技\n",
      "工商银行\n",
      "小米集团-W\n",
      "中国铁塔\n",
      "富力地产\n",
      "中国电信\n",
      "瑞声科技\n",
      "中国银行\n",
      "银河娱乐\n",
      "汇丰控股\n",
      "中国海洋石油\n",
      "招商银行\n",
      "中国人寿\n",
      "中国海外发展\n",
      "翰森制药\n",
      "融创中国\n",
      "中国联通\n",
      "金沙中国有限公司\n",
      "吉利汽车\n",
      "保利物业\n",
      "中国生物制药\n",
      "新鸿基地产\n",
      "中国石油化工股份\n",
      "长和\n",
      "华润置地\n",
      "石药集团\n",
      "比亚迪股份\n",
      "广汽集团\n",
      "中信证券\n",
      "农业银行\n",
      "安踏体育\n",
      "中国石油股份\n",
      "长实集团\n",
      "药明生物\n",
      "万洲国际\n",
      "联想集团\n",
      "中电控股\n",
      "波司登\n",
      "万科企业\n",
      "碧桂园\n",
      "恒生银行\n",
      "九龙仓置业\n",
      "中国神华\n",
      "中广核电力\n",
      "中国太保\n",
      "港铁公司\n",
      "邮储银行\n",
      "申洲国际\n",
      "中国恒大\n",
      "中国东方教育\n",
      "香港中华煤气\n",
      "中银香港\n",
      "永利澳门\n",
      "药明康德\n",
      "华润啤酒\n",
      "中国建材\n",
      "恒安国际\n",
      "海螺水泥\n",
      "蒙牛乳业\n",
      "龙湖集团\n",
      "中国燃气\n",
      "中国财险\n",
      "中芯国际\n",
      "海螺创业\n",
      "北控水务集团\n",
      "交通银行\n",
      "电能实业\n",
      "锦欣生殖\n",
      "太古股份公司A\n",
      "新世界发展\n",
      "时代邻里\n",
      "百威亚太\n",
      "新华保险\n",
      "新奥能源\n",
      "粤海投资\n",
      "中信股份\n",
      "平安好医生\n",
      "金山软件\n",
      "长城汽车\n",
      "世茂房地产\n",
      "中国交通建设\n",
      "华能新能源\n",
      "三生制药\n",
      "中金公司\n",
      "香港电讯-SS\n",
      "中兴通讯\n",
      "中海油田服务\n",
      "正荣地产\n",
      "海通证券\n",
      "中信银行\n",
      "李宁\n",
      "创科实业\n",
      "中国旺旺\n",
      "信义光能\n",
      "紫金矿业\n",
      "海尔电器\n",
      "阿里健康\n",
      "潍柴动力\n",
      "昆仑能源\n",
      "中烟香港\n",
      "会德丰\n",
      "中国人民保险集团\n",
      "华晨中国\n",
      "华润燃气\n",
      "丘钛科技\n",
      "东风集团股份\n",
      "华泰证券\n",
      "众安在线\n",
      "心动公司\n",
      "中国软件国际\n",
      "天立教育\n",
      "碧桂园服务\n",
      "龙源电力\n",
      "长江基建集团\n",
      "中国中车\n",
      "恒基地产\n",
      "高鑫零售\n",
      "海底捞\n",
      "中国飞鹤\n",
      "民生银行\n",
      "中梁控股\n",
      "阅文集团\n",
      "太古地产\n",
      "颐海国际\n",
      "中国中铁\n",
      "比亚迪电子\n",
      "敏实集团\n",
      "中国光大国际\n",
      "国药控股\n",
      "华虹半导体\n",
      "旭辉控股集团\n",
      "九龙仓集团\n",
      "中联重科\n",
      "恒隆地产\n",
      "康师傅控股\n",
      "时代中国控股\n",
      "东阳光药\n",
      "龙光地产\n",
      "信和置业\n",
      "信德集团\n",
      "澳博控股\n",
      "世纪集团国际\n",
      "信义玻璃\n",
      "建滔集团\n",
      "金蝶国际\n",
      "复星国际\n",
      "华润电力\n",
      "新东方在线\n",
      "普拉达\n",
      "绿叶制药\n",
      "新城发展\n",
      "合景泰富集团\n",
      "青岛啤酒股份\n",
      "中手游\n",
      "金斯瑞生物科技\n",
      "中信建投证券\n",
      "中国银河\n",
      "电讯盈科\n",
      "康哲药业\n",
      "华润医药\n",
      "中国铁建\n",
      "华润水泥控股\n",
      "玖龙纸业\n",
      "信达生物-B\n",
      "中国海外宏洋集团\n",
      "ASM PACIFIC\n",
      "中国中药\n",
      "中国金茂\n",
      "新秀丽\n",
      "中航科工\n",
      "中国通信服务\n",
      "洛阳钼业\n",
      "雅生活服务\n",
      "中国太平\n",
      "赣锋锂业\n",
      "招金矿业\n",
      "中国国航\n",
      "希慎兴业\n",
      "福耀玻璃\n",
      "北京控股\n",
      "新濠国际发展\n",
      "联邦制药\n",
      "中国奥园\n",
      "新创建集团\n",
      "建发国际集团\n",
      "鞍钢股份\n",
      "广发证券\n",
      "中车时代电气\n",
      "华能国际电力股份\n",
      "兖州煤业股份\n",
      "四环医药\n",
      "大昌行集团\n",
      "招商局港口\n",
      "港灯-SS\n",
      "哈尔滨电气\n",
      "中升控股\n",
      "康龙化成\n",
      "敏华控股\n",
      "中国联塑\n",
      "周大福\n",
      "江苏宁沪高速公路\n",
      "中信国际电讯\n",
      "中国信达\n",
      "中国通号\n",
      "上海医药\n",
      "中国重汽\n",
      "威高股份\n",
      "大家乐集团\n",
      "美高梅中国\n",
      "人瑞人才\n",
      "爱康医疗\n",
      "中银航空租赁\n",
      "复星医药\n",
      "嘉里建设\n",
      "上海石油化工股份\n",
      "中国民航信息网络\n",
      "保利协鑫能源\n",
      "金风科技\n",
      "金界控股\n",
      "JS环球生活\n",
      "雅居乐集团\n",
      "东亚银行\n",
      "美的置业\n",
      "裕元集团\n",
      "VTECH HOLDINGS\n",
      "江西铜业股份\n",
      "阿里影业\n",
      "通达集团\n",
      "海通国际\n",
      "渣打集团\n",
      "中国光大控股\n",
      "深圳国际\n",
      "申万宏源\n",
      "统一企业中国\n",
      "佳兆业集团\n",
      "中骏集团控股\n",
      "协鑫新能源\n",
      "中远海能\n",
      "中国光大银行\n",
      "IGG\n",
      "中国建筑国际\n",
      "中粮肉食\n",
      "禹洲地产\n",
      "远东宏信\n",
      "东岳集团\n",
      "中国粮油控股\n",
      "利丰\n",
      "正通汽车\n",
      "新城悦服务\n",
      "中国华融\n",
      "瑞安房地产\n",
      "马鞍山钢铁股份\n",
      "越秀地产\n",
      "创维集团\n",
      "重庆农村商业银行\n",
      "长江生命科技\n",
      "绿城中国\n",
      "国泰航空\n",
      "猫眼娱乐\n",
      "同程艺龙\n",
      "山东黄金\n",
      "浙江沪杭甬\n",
      "雷士照明\n",
      "国美零售\n",
      "北京首都机场股份\n",
      "绿城服务\n",
      "建滔积层板\n",
      "五矿资源\n",
      "启明医疗-B\n",
      "特步国际\n",
      "福莱特玻璃\n",
      "海信家电\n",
      "深圳高速公路股份\n",
      "周黑鸭\n",
      "北京汽车\n",
      "达利食品\n",
      "海丰国际\n",
      "宇华教育\n",
      "福寿园\n",
      "富智康集团\n",
      "澳优\n",
      "中远海运港口\n",
      "酷派集团\n",
      "中教控股\n",
      "石四药集团\n",
      "理文造纸\n",
      "白云山\n",
      "耐世特\n",
      "永达汽车\n",
      "宝龙地产\n",
      "中国南方航空股份\n",
      "三盛控股\n",
      "中集集团\n",
      "雅各臣科研制药\n",
      "兑吧\n",
      "乐游科技控股\n",
      "融信中国\n",
      "海天国际\n",
      "中国水务\n",
      "上海复旦\n",
      "途屹控股\n",
      "安徽皖通高速公路\n",
      "永升生活服务\n",
      "国泰君安\n",
      "中国铝业\n",
      "瑞诚中国传媒\n",
      "远东发展\n",
      "南方能源\n",
      "中国东方集团\n",
      "港华燃气\n",
      "六福集团\n",
      "保利置业集团\n",
      "梁志天设计集团\n",
      "H&H国际控股\n",
      "深圳控股\n",
      "东方证券\n",
      "中集安瑞科\n",
      "中海物业\n",
      "第一太平\n",
      "嘉华国际\n",
      "中国电力\n",
      "康希诺生物-B\n",
      "上海电气\n",
      "爱得威建设集团\n",
      "中远海控\n",
      "嘉里物流\n",
      "首控集团\n",
      "恒隆集团\n",
      "阜博集团\n",
      "联想控股\n",
      "亚洲水泥(中国)\n",
      "京信通信\n",
      "方达控股\n",
      "远洋集团\n",
      "香港宽频\n",
      "香港教育国际\n",
      "光大证券\n",
      "鹰君\n",
      "维珍妮\n",
      "招商证券\n",
      "丽珠医药\n",
      "滔搏\n",
      "成实外教育\n",
      "康宁杰瑞制药-B\n",
      "安东油田服务\n",
      "德昌电机控股\n",
      "网龙\n",
      "大新金融\n",
      "云顶香港\n",
      "福晟国际\n",
      "SPROCOMM INTEL\n",
      "微盟集团\n",
      "FIT HON TENG\n",
      "大发地产\n",
      "上海实业控股\n",
      "首创置业\n",
      "微创医疗\n",
      "奥园健康\n",
      "阜丰集团\n",
      "中国宏桥\n",
      "三一国际\n",
      "太古股份公司B\n",
      "太阳城集团\n",
      "绿景中国地产\n",
      "国泰君安国际\n",
      "SOHO中国\n",
      "卓尔智联\n",
      "高伟电子\n",
      "百富环球\n",
      "中国忠旺\n",
      "维达国际\n",
      "周生生\n",
      "惠理集团\n",
      "同仁堂科技\n",
      "天虹纺织\n",
      "承达集团\n",
      "长飞光纤光缆\n",
      "越秀交通基建\n",
      "赢家时尚\n",
      "数码通电讯\n",
      "中国光大绿色环保\n",
      "和谐汽车\n",
      "中州证券\n",
      "大唐发电\n",
      "宏基集团控股\n",
      "路劲\n",
      "艾伯科技\n",
      "香格里拉(亚洲)\n",
      "新天绿色能源\n",
      "中国东方航空股份\n",
      "互太纺织\n",
      "中石化炼化工程\n",
      "香港中旅\n",
      "金隅集团\n",
      "日清食品\n",
      "环球医疗\n",
      "好孩子国际\n",
      "东方电气\n",
      "卡森国际\n",
      "易居企业控股\n",
      "枫叶教育\n",
      "中国利郎\n",
      "中国同辐\n",
      "迈科管业\n",
      "雷蛇\n",
      "先健科技\n",
      "信恳智能\n",
      "力高集团\n",
      "太平洋航运\n",
      "嘉年华国际\n",
      "泛亚国际\n",
      "中国外运\n",
      "神州控股\n",
      "同方康泰\n",
      "雅迪控股\n",
      "建业地产\n",
      "俄铝\n",
      "华电国际电力股份\n",
      "星宇控股\n",
      "重庆银行\n",
      "中煤能源\n",
      "NEWTREE GROUP\n",
      "美图公司\n",
      "西证国际证券\n",
      "ESR\n",
      "新意网集团\n",
      "绿科科技国际\n",
      "恒腾网络\n",
      "依波路\n",
      "中国中冶\n",
      "中国飞机租赁\n",
      "雅高控股\n",
      "信利国际\n",
      "中国再保险\n",
      "创梦天地\n",
      "百济神州\n",
      "中石化冠德\n",
      "利福国际\n",
      "云南建投混凝土\n",
      "和记电讯香港\n",
      "莎莎国际\n",
      "西部水泥\n",
      "蓝光嘉宝服务\n",
      "泰林科建\n",
      "高银金融\n",
      "信义能源\n",
      "红星美凯龙\n",
      "有才天下猎聘\n",
      "汇付天下\n",
      "锦江资本\n",
      "索信达控股\n",
      "百仕达控股\n",
      "晨鸣纸业\n",
      "新力控股集团\n",
      "天能动力\n",
      "华记环球集团\n",
      "南海控股\n",
      "盛业资本\n",
      "佳兆业美好\n",
      "春立医疗\n",
      "首钢资源\n",
      "达飞控股\n",
      "天工国际\n",
      "博奇环保\n",
      "丰盛服务集团\n",
      "松龄护老集团\n",
      "中国龙工\n",
      "合生创展集团\n",
      "新高教集团\n",
      "易鑫集团\n",
      "中国科培\n",
      "丰盛控股\n",
      "华众车载\n",
      "中化化肥\n",
      "洛阳玻璃股份\n",
      "中远海发\n",
      "伟仕佳杰\n",
      "宝胜国际\n",
      "中粮包装\n",
      "思考乐教育\n",
      "恒新丰控股\n",
      "美东汽车\n",
      "中国机械工程\n",
      "中国天瑞水泥\n",
      "勋龙\n",
      "信基沙溪\n",
      "弘阳地产\n",
      "冠城钟表珠宝\n",
      "意达利控股\n",
      "呷哺呷哺\n",
      "佳源国际控股\n",
      "KEE\n",
      "天伦燃气\n",
      "TCL电子\n",
      "大唐西市\n",
      "慧聪集团\n",
      "东江环保\n",
      "中国智能集团\n",
      "江西银行\n",
      "华南城\n",
      "华润医疗\n",
      "维亚生物\n",
      "联洋智能控股\n",
      "金地商置\n",
      "中航国际控股\n",
      "亚太资源\n",
      "九兴控股\n",
      "北京北辰实业股份\n",
      "华宝国际\n",
      "华电福新\n",
      "大新银行集团\n",
      "凯升控股\n",
      "中国三江化工\n",
      "创陞控股\n",
      "FRIENDTIMES\n",
      "绿地香港\n",
      "FAIRWOOD HOLD\n",
      "亚信科技\n",
      "天誉置业\n",
      "中裕燃气\n",
      "景瑞控股\n",
      "泰升集团\n",
      "中汇集团\n",
      "中国卫生集团\n",
      "云裳衣\n",
      "鲁大师\n",
      "嘉涛(香港)控股\n",
      "神威药业\n",
      "君实生物-B\n",
      "远大医药\n",
      "宝宝树集团\n",
      "国瑞置业\n",
      "胜狮货柜\n",
      "上实城市开发\n",
      "香港电视\n",
      "澳门励骏\n",
      "中国高速传动\n",
      "魏桥纺织\n",
      "威华达控股\n",
      "雄岸科技\n",
      "陆氏集团(越南)\n",
      "中广核新能源\n",
      "中国优材\n",
      "东方海外国际\n",
      "鼎石资本\n",
      "浦江国际\n",
      "同仁堂国药\n",
      "鼎丰集团控股\n",
      "东方表行集团\n",
      "TBKS HLDGS\n",
      "利标品牌\n",
      "中国汽车新零售\n",
      "共享集团\n",
      "花样年控股\n",
      "宝新金融\n",
      "中国能源建设\n",
      "彩客化学\n",
      "中国新华教育\n",
      "西藏水资源\n",
      "朗廷-SS\n",
      "诺发集团\n",
      "大酒店\n",
      "爱帝宫\n",
      "江南布衣\n",
      "歌礼制药-B\n",
      "通力电子\n",
      "华显光电\n",
      "现代牧业\n",
      "希望教育\n",
      "中国食品\n",
      "大悦城地产\n",
      "伟禄集团\n",
      "资本策略地产\n",
      "必瘦站\n",
      "DYNAM JAPAN\n",
      "电视广播\n",
      "康臣药业\n",
      "青岛港\n",
      "彩生活\n",
      "宏利金融-S\n",
      "广汇宝信\n",
      "第一拖拉机股份\n",
      "联合能源集团\n",
      "中国黄金国际\n",
      "恒大健康\n",
      "管道工程\n",
      "51信用卡\n",
      "云锋金融\n",
      "华检医疗\n",
      "奥星生命科技\n",
      "慕尚集团控股\n",
      "卓越教育集团\n",
      "中国金属利用\n",
      "香港兴业国际\n",
      "粤丰环保\n",
      "佐丹奴国际\n",
      "神州租车\n",
      "中播控股\n",
      "天津银行\n",
      "南京熊猫电子股份\n",
      "中环控股\n",
      "万咖壹联\n",
      "第七大道\n",
      "中国旭阳集团\n",
      "冠华国际控股\n",
      "中国汇融\n",
      "昊海生物科技\n",
      "本间高尔夫\n",
      "天津港发展\n",
      "香港潮商集团\n",
      "昂纳科技集团\n",
      "泰凌医药\n",
      "景业名邦集团\n",
      "华地国际控股\n",
      "新鸿基公司\n",
      "北控清洁能源集团\n",
      "友联租赁\n",
      "亚美能源\n",
      "中国服饰控股\n",
      "五龙电动车\n",
      "卜蜂国际\n",
      "槟杰科达\n",
      "快餐帝国\n",
      "中远海运国际\n",
      "维信金科\n",
      "基石药业-B\n",
      "思捷环球\n",
      "美兰空港\n",
      "数字王国\n",
      "火币科技\n",
      "中船防务\n",
      "汇量科技\n",
      "庆铃汽车股份\n",
      "HOME CONTROL\n",
      "光宇国际集团科技\n",
      "荣智控股\n",
      "其利工业集团\n",
      "21世纪教育\n",
      "绿色动力环保\n",
      "恒达科技控股\n",
      "凌锐控股\n",
      "时代集团控股\n",
      "中能控股\n",
      "万城控股\n",
      "中集车辆\n",
      "耀才证券金融\n",
      "优品360\n",
      "巨腾国际\n",
      "天韵国际控股\n",
      "361度\n",
      "太兴集团\n",
      "重庆钢铁股份\n",
      "捷隆控股\n",
      "德视佳\n",
      "康德莱医械\n",
      "宏安地产\n",
      "奥思集团\n",
      "力世纪\n",
      "登辉控股\n",
      "河北建设\n",
      "星光文化\n",
      "紫光控股\n",
      "博尼控股\n",
      "广深铁路股份\n",
      "国锐地产\n",
      "金鹰商贸集团\n",
      "兴达国际\n",
      "柏能集团\n",
      "浦林成山\n",
      "协合新能源\n",
      "金卫医疗\n",
      "中信资源\n",
      "拉夏贝尔\n",
      "新海能源\n",
      "中国北大荒\n",
      "东瑞制药\n",
      "中海石油化学\n",
      "中国航空工业国际\n",
      "国微控股\n",
      "百德国际\n",
      "伟能集团\n",
      "中国船舶租赁\n",
      "华夏动漫\n",
      "宏华集团\n",
      "海通恒信\n",
      "五谷磨房\n",
      "美丽华酒店\n",
      "欢喜传媒\n",
      "中国抗体-B\n",
      "海昌海洋公园\n",
      "威胜控股\n",
      "守益控股\n",
      "浪潮国际\n",
      "康特隆\n",
      "中石化油服\n",
      "纷美包装\n",
      "鲜驰达控股\n",
      "万国国际矿业\n",
      "希玛眼科\n",
      "高阳科技\n",
      "辰林教育\n",
      "大成生化科技\n",
      "民银资本\n",
      "新华文轩\n",
      "家乡互动\n",
      "珠海控股投资\n",
      "华人置业\n",
      "亚太卫星\n",
      "东京中央拍卖\n",
      "万宝盛华\n",
      "大森控股\n",
      "移动互联(中国)\n",
      "稀镁科技\n",
      "中国物流资产\n",
      "德永佳集团\n",
      "甘肃银行\n",
      "兴业太阳能\n",
      "国浩集团\n",
      "国际家居零售\n",
      "瑞风新能源\n",
      "中国动向\n",
      "惠生工程\n",
      "虎都\n",
      "博华太平洋\n",
      "睿见教育\n",
      "瑞斯康集团\n",
      "俊知集团\n",
      "百宏实业\n",
      "丽新发展\n",
      "瑞安建业\n",
      "宝新置地\n",
      "翼辰实业\n",
      "四川成渝高速公路\n",
      "科通芯城\n",
      "徽商银行\n",
      "绿新亲水胶体\n",
      "HYPEBEAST\n",
      "众诚能源\n",
      "味千(中国)\n",
      "中国白银集团\n",
      "山水水泥\n",
      "中国新经济投资\n",
      "首创环境\n",
      "亿胜生物科技\n",
      "信邦控股\n",
      "航天控股\n",
      "鸿宝资源\n",
      "蓝鼎国际\n",
      "义合控股\n",
      "金川国际\n",
      "白马户外媒体\n",
      "四川能投发展\n",
      "星岛\n",
      "中国天然气\n",
      "联华超市\n",
      "京东方精电\n",
      "荣威国际\n",
      "华兴资本控股\n",
      "创兴银行\n",
      "英皇娱乐酒店\n",
      "畅捷通\n",
      "恒基发展\n",
      "中国宏泰发展\n",
      "大自然家居\n",
      "天津创业环保股份\n",
      "载通\n",
      "鑫苑服务\n",
      "浙商银行\n",
      "前进控股集团\n",
      "中国山东高速金融\n",
      "九龙建业\n",
      "大健康国际\n",
      "光启科学\n",
      "廖创兴企业\n",
      "香港医思医疗集团\n",
      "鹰普精密\n",
      "熊猫绿能\n",
      "美瑞健康国际\n",
      "大唐新能源\n",
      "珠光控股\n",
      "茂业国际\n",
      "雨润食品\n",
      "尚捷集团控股\n",
      "百奥家庭互动\n",
      "现代牙科\n",
      "金邦达宝嘉\n",
      "苍南仪表\n",
      "晶苑国际\n",
      "辰兴发展\n",
      "澳能建设\n",
      "AV CONCEPT HOLD\n",
      "李氏大药厂\n",
      "亚盛医药-B\n",
      "新沣集团\n",
      "IMAX CHINA\n",
      "滉达富控股\n",
      "中国稀土\n",
      "冠轈控股\n",
      "开元酒店\n",
      "银城国际控股\n",
      "太睿国际控股\n",
      "英皇国际\n",
      "达力集团\n",
      "盛京银行\n",
      "基石控股\n",
      "WING ON CO\n",
      "飞扬集团\n",
      "原生态牧业\n",
      "邵氏兄弟控股\n",
      "国际资源\n",
      "招商局置地\n",
      "高陞集团控股\n",
      "德信中国\n",
      "青岛银行\n",
      "VICON HOLDINGS\n",
      "恒益控股\n",
      "丽丰控股\n",
      "郑煤机\n",
      "申万宏源香港\n",
      "元征科技\n",
      "比速科技\n",
      "安捷利实业\n",
      "郑州银行\n",
      "达芙妮国际\n",
      "兆邦基地产\n",
      "爪哇控股\n",
      "天安\n",
      "理文化工\n",
      "龙记集团\n",
      "香港小轮(集团)\n",
      "五矿地产\n",
      "大中华金融\n",
      "华侨城(亚洲)\n",
      "中国绿岛科技\n",
      "I.T\n",
      "万隆控股集团\n",
      "中国罕王\n",
      "中渝置地\n",
      "港亚控股\n",
      "科联系统\n",
      "道和环球\n",
      "美建集团\n",
      "联康生物科技集团\n",
      "秦港股份\n",
      "星星地产\n",
      "大众公用\n",
      "哈尔滨银行\n",
      "BC科技集团\n",
      "中国动力控股\n",
      "中广核矿业\n",
      "丽新国际\n",
      "北控医疗健康\n",
      "亚洲电视控股\n",
      "湾区发展\n",
      "富道集团\n",
      "恒兴黄金\n",
      "晋商银行\n",
      "上海集优\n",
      "澳洲成峰高教\n",
      "赛伯乐国际控股\n",
      "中国中石控股\n",
      "禅游科技\n",
      "民生教育\n",
      "中国心连心化肥\n",
      "捷荣国际控股\n",
      "复星旅游文化\n",
      "普汇中金国际\n",
      "钱唐控股\n",
      "海峡石油化工\n",
      "胜龙国际\n",
      "天山发展控股\n",
      "雅仕维\n",
      "日成控股\n",
      "恒发光学\n",
      "江南集团\n",
      "汇盈控股\n",
      "银杏教育\n",
      "华禧控股\n",
      "双运控股\n",
      "德基科技控股\n",
      "方正控股\n",
      "摩比发展\n",
      "英皇证券\n",
      "凤凰卫视\n",
      "鑫网易商\n",
      "汤臣集团\n",
      "中国圣牧\n",
      "三爱健康集团\n",
      "易大宗\n",
      "TAI CHEUNG HOLD\n",
      "金利来集团\n",
      "东曜药业-B\n",
      "中国全通\n",
      "元亨燃气\n",
      "华滋国际海洋\n",
      "天福\n",
      "大众金融控股\n",
      "激成投资\n",
      "超威动力\n",
      "保华集团\n",
      "东江集团控股\n",
      "康达环保\n",
      "通天酒业\n",
      "都市丽人\n",
      "亿和控股\n",
      "银城生活服务\n",
      "青建国际\n",
      "益美国际控股\n",
      "中智药业\n",
      "华油能源\n",
      "筑友智造科技\n",
      "中国赛特\n",
      "中国地利\n",
      "浩泽净水\n",
      "齐屹科技\n",
      "西王特钢\n",
      "新兴光学\n",
      "广泽国际发展\n",
      "长盈集团(控股)\n",
      "大连港\n",
      "中奥到家\n",
      "中电光谷\n",
      "天津发展\n",
      "福田实业\n",
      "设计都会\n",
      "上海实业环境\n",
      "科劲国际\n",
      "NATIONAL ELEC H\n",
      "福森药业\n",
      "北方矿业\n",
      "岁宝百货\n",
      "扬科集团\n",
      "中国航天万源\n",
      "北京体育文化\n",
      "金活医药集团\n",
      "健升物流中国\n",
      "威铖国际\n",
      "德泰新能源集团\n",
      "汇银智慧社区\n",
      "金利丰金融\n",
      "山东墨龙\n",
      "王氏国际\n",
      "新世界百货中国\n",
      "老恒和酿造\n",
      "中策集团\n",
      "东正金融\n",
      "AEON CREDIT\n",
      "结好控股\n",
      "WAI KEE HOLD\n",
      "厦门港务\n",
      "复旦张江\n",
      "中智全球\n",
      "滨江服务\n",
      "环亚国际实业\n",
      "阳光纸业\n",
      "铁建装备\n",
      "恒宇集团\n",
      "南方通信\n",
      "谭木匠\n",
      "招商局中国基金\n",
      "津上机床中国\n",
      "铁货\n",
      "润中国际控股\n",
      "五菱汽车\n",
      "正利控股\n",
      "新晨动力\n",
      "LFG投资控股\n",
      "海港企业\n",
      "自动系统\n",
      "伊泰煤炭\n",
      "米技国际控股\n",
      "剑虹集团控股\n",
      "美联集团\n",
      "香港建设(控股)\n",
      "正商实业\n",
      "港大零售\n",
      "中国星集团\n",
      "沧海控股\n",
      "智美体育\n",
      "中昌国际控股\n",
      "世纪联合控股\n",
      "万科海外\n",
      "银建国际\n",
      "松景科技\n",
      "北京燃气蓝天\n",
      "财讯传媒\n",
      "飞尚无烟煤\n",
      "未来世界金融\n",
      "彩虹新能源\n",
      "经济日报集团\n",
      "东英金融\n",
      "翠华控股\n",
      "优创金融\n",
      "天津津燃公用\n",
      "中国环保能源\n",
      "信阳毛尖\n",
      "港通控股\n",
      "中国民生金融\n",
      "震雄集团\n",
      "中国建筑兴业\n",
      "鼎亿集团投资\n",
      "博雅互动\n",
      "京能清洁能源\n",
      "亨得利\n",
      "中油燃气\n",
      "京基金融国际\n",
      "顺腾国际控股\n",
      "恒达集团控股\n",
      "上置集团\n",
      "植华集团\n",
      "城建设计\n",
      "中国光大水务\n",
      "新疆新鑫矿业\n",
      "利宝阁集团\n",
      "珠江船务\n",
      "滇池水务\n",
      "利华控股集团\n",
      "勇利投资\n",
      "浙江世宝\n",
      "中国擎天软件\n",
      "东瀛游\n",
      "云智汇科技\n",
      "东方报业集团\n",
      "长寿花食品\n",
      "久泰邦达能源\n",
      "保利达资产\n",
      "交银国际\n",
      "彩星集团\n",
      "珩湾科技\n",
      "训修实业\n",
      "复宏汉霖-B\n",
      "远大住工\n",
      "华讯\n",
      "耀莱集团\n",
      "春城热力\n",
      "昊天发展集团\n",
      "第一视频\n",
      "长城环亚控股\n",
      "万达酒店发展\n",
      "中海重工\n",
      "中国诚通发展集团\n",
      "太平洋网络\n",
      "荣晖国际\n",
      "碧生源\n",
      "中国万桐园\n",
      "橙天嘉禾\n",
      "恒盛地产\n",
      "贸易通\n",
      "中怡国际\n",
      "S&T HLDGS\n",
      "香港金融集团\n",
      "英皇文化产业\n",
      "BENG SOON MACH\n",
      "茂盛控股\n",
      "映客\n",
      "当代置业\n",
      "顺兴集团控股\n",
      "鲁证期货\n",
      "伯明翰体育\n",
      "维港环保科技\n",
      "云南水务\n",
      "鸿兴印刷集团\n",
      "莱蒙国际\n",
      "安宁控股\n",
      "荣阳实业\n",
      "中国绿宝\n",
      "中国核能科技\n",
      "灵宝黄金\n",
      "安乐工程\n",
      "众安集团\n",
      "王朝酒业\n",
      "阳光100中国\n",
      "启迪国际\n",
      "茂宸集团\n",
      "南旋控股\n",
      "正道集团\n",
      "龙辉国际控股\n",
      "世纪城市国际\n",
      "亚太丝路投资\n",
      "CMON\n",
      "上谕集团\n",
      "首长宝佳\n",
      "亨鑫科技\n",
      "超智能控股\n",
      "百信国际\n",
      "弘业期货\n",
      "华立大学\n",
      "保德国际发展\n",
      "文化传信\n",
      "保利文化\n",
      "绿领控股\n",
      "富汇建筑控股\n",
      "金朝阳集团\n",
      "新昌创展控股\n",
      "海升果汁\n",
      "仁天科技控股\n",
      "荣丰联合控股\n",
      "腾邦控股\n",
      "力量能源\n",
      "第一上海\n",
      "SHOUGANG GRAND\n",
      "国际精密\n",
      "伟鸿集团控股\n",
      "利福中国\n",
      "新世纪医疗\n",
      "汛和集团\n",
      "中华汽车\n",
      "中国金石\n",
      "庄士中国\n",
      "云游控股\n",
      "日照港裕廊\n",
      "金茂酒店-SS\n",
      "创联教育金融\n",
      "泛海集团\n",
      "佳宁娜\n",
      "天臣控股\n",
      "世界华文媒体\n",
      "中达集团控股\n",
      "彼岸控股\n",
      "坤集团\n",
      "英达公路再生科技\n",
      "世纪阳光\n",
      "兴科蓉医药\n",
      "协同通信\n",
      "中国金融租赁\n",
      "嘉利国际\n",
      "圆通速递国际\n",
      "兴胜创建\n",
      "北京建设\n",
      "中原银行\n",
      "普华和顺\n",
      "重庆机电\n",
      "联合地产(香港)\n",
      "侨雄国际\n",
      "中电华大科技\n",
      "信星集团\n",
      "BBI生命科学\n",
      "S.A.S. DRAGON\n",
      "中盈盛达融资担保\n",
      "中国富强金融\n",
      "黎氏企业\n",
      "世纪娱乐国际\n",
      "国投集团控股\n",
      "飞达控股\n",
      "光控精技\n",
      "新焦点\n",
      "东北电气\n",
      "澳科控股\n",
      "华金国际资本\n",
      "PICO FAR EAST\n",
      "江山控股\n",
      "汇彩控股\n",
      "中信大锰\n",
      "嘉宏教育\n",
      "TOM集团\n",
      "凯普松国际\n",
      "壹传媒\n",
      "百福控股\n",
      "利亚零售\n",
      "卡宾\n",
      "永嘉集团\n",
      "阳光油砂\n",
      "集一家居\n",
      "同得仕(集团)\n",
      "日赢控股\n",
      "达力环保\n",
      "狮子山集团\n",
      "中国疏浚环保\n",
      "华融金控\n",
      "东方明珠石油\n",
      "同方泰德\n",
      "盈大地产\n",
      "首都信息\n",
      "华领医药-B\n",
      "STYLAND HOLD\n",
      "汇聚科技\n",
      "标准资源控股\n",
      "大生地产\n",
      "大禹金融\n",
      "华谊腾讯娱乐\n",
      "坛金矿业\n",
      "香港建屋贷款\n",
      "指尖悦动\n",
      "森美控股\n",
      "复锐医疗科技\n",
      "企展控股\n",
      "铭霖控股\n",
      "嘉瑞国际\n",
      "兴发铝业\n",
      "励晶太平洋\n",
      "中国环境资源\n",
      "悦达国际控股\n",
      "中盈集团控股\n",
      "天长集团\n",
      "毛记葵涌\n",
      "金达控股\n",
      "世纪金花\n",
      "神冠控股\n",
      "川控股\n",
      "巨涛海洋石油服务\n",
      "味丹国际\n",
      "天彩控股\n",
      "中泛控股\n",
      "KFM金德\n",
      "易生活控股\n",
      "冠军科技集团\n",
      "创建集团控股\n",
      "向中国际\n",
      "中国优通\n",
      "旷逸国际\n",
      "佳明集团控股\n",
      "大生农业金融\n",
      "南华集团控股\n",
      "叶氏化工集团\n",
      "亚洲联合基建控股\n",
      "友佳国际\n",
      "精熙国际\n",
      "联泰控股\n",
      "传递娱乐\n",
      "中能国际控股\n",
      "美高域\n",
      "中国透云\n",
      "富临集团控股\n",
      "国际娱乐\n",
      "庄臣控股\n",
      "B & D STRATEGIC\n",
      "顺风清洁能源\n",
      "英皇钟表珠宝\n",
      "利邦\n",
      "中集天达\n",
      "远东酒店实业\n",
      "亚积邦租赁\n",
      "润东汽车\n",
      "宝业集团\n",
      "百勤油服\n",
      "时富金融服务集团\n",
      "京城机电股份\n",
      "飞毛腿\n",
      "阳光能源\n",
      "普甜食品\n",
      "结好金融\n",
      "新明中国\n",
      "普天通信集团\n",
      "宏基资本\n",
      "长城一带一路\n",
      "珀丽酒店\n",
      "金源米业\n",
      "明辉国际\n",
      "海亮国际\n",
      "中国鹏飞集团\n",
      "天源集团\n",
      "齐合环保\n",
      "九江银行\n",
      "恩达集团控股\n",
      "高山企业\n",
      "迪臣发展国际\n",
      "康宁医院\n",
      "新世纪集团\n",
      "弘达金融控股\n",
      "迪信通\n",
      "首沣控股\n",
      "中国铝罐\n",
      "华营建筑\n",
      "太和控股\n",
      "中国资源交通\n",
      "MONGOL MINING\n",
      "九号运通\n",
      "合兴集团\n",
      "千百度\n",
      "PALADIN\n",
      "童园国际\n",
      "中誉集团\n",
      "青岛控股\n",
      "FUTURE BRIGHT\n",
      "中国艺术金融\n",
      "保宝龙科技\n",
      "新时代能源\n",
      "和泓服务\n",
      "环球信贷集团\n",
      "建鹏控股\n",
      "誉宴集团\n",
      "天瑞汽车内饰\n",
      "芯智控股\n",
      "中国金控\n",
      "银涛控股\n",
      "富阳\n",
      "中国烯谷集团\n",
      "年年卡\n",
      "延长石油国际\n",
      "湾区黄金\n",
      "华商国际海洋控股\n",
      "百盛集团\n",
      "美亨实业\n",
      "领航医药生物科技\n",
      "伟俊集团控股\n",
      "创业集团控股\n",
      "国际天食\n",
      "龙资源\n",
      "国安国际\n",
      "中国天保集团\n",
      "开源控股\n",
      "FSM HOLDINGS\n",
      "IBI GROUP HLDGS\n",
      "JOYCE BOUTIQUE\n",
      "粤运交通\n",
      "平安证券集团控股\n",
      "莱尔斯丹\n",
      "有线宽频\n",
      "伟工控股\n",
      "天保能源\n",
      "环宇物流(亚洲)\n",
      "谊砾控股\n",
      "中国织材控股\n",
      "山东国信\n",
      "保诚\n",
      "天业节水\n",
      "融太集团\n",
      "德莱建业\n",
      "FAST RETAIL-DRS\n",
      "建溢集团\n",
      "彩星玩具\n",
      "WKK INTL (HOLD)\n",
      "梧桐国际\n",
      "信源企业集团\n",
      "天鸽互动\n",
      "中华国际\n",
      "亨泰\n",
      "山东新华制药股份\n",
      "达力普控股\n",
      "京投交通科技\n",
      "游莱互动\n",
      "煜荣集团\n",
      "兴华港口\n",
      "国华\n",
      "天元医疗\n",
      "意马国际\n",
      "恒富控股\n",
      "久融控股\n",
      "伟志控股\n",
      "鹰美\n",
      "鸿福堂\n",
      "华邦金融\n",
      "德祥地产\n",
      "致丰工业电子\n",
      "慕容控股\n",
      "雅士利国际\n",
      "安莉芳控股\n",
      "北大资源\n",
      "PERSTA\n",
      "STERLING GP\n",
      "海隆控股\n",
      "UTS MARKETING\n",
      "中国农产品交易\n",
      "华新手袋国际控股\n",
      "钧濠集团\n",
      "中国宝丰国际\n",
      "稻香控股\n",
      "皇冠环球集团\n",
      "恒鼎实业\n",
      "中国上城\n",
      "瀚华金控\n",
      "远见控股\n",
      "IDG能源投资\n",
      "阿尔法企业\n",
      "天利控股集团\n",
      "国美金融科技\n",
      "合富辉煌\n",
      "电讯数码控股\n",
      "兴纺控股\n",
      "中国国家文化产业\n",
      "SOLOMON SYSTECH\n",
      "火岩控股\n",
      "润利海事\n",
      "创世纪集团控股\n",
      "域高国际控股\n",
      "K2 F&B\n",
      "新工投资\n",
      "胜利管道\n",
      "永泰地产\n",
      "唐宫中国\n",
      "新城市建设发展\n",
      "NANYANG HOLD\n",
      "朗诗地产\n",
      "常茂生物\n",
      "毅德国际\n",
      "嘉艺控股\n",
      "A8新媒体\n",
      "霭华押业信贷\n",
      "上海证大\n",
      "中国育儿网络\n",
      "象兴国际\n",
      "璋利国际\n",
      "中民控股\n",
      "星凯控股\n",
      "华君国际集团\n",
      "白花油\n",
      "博骏教育\n",
      "中国绿地博大绿泽\n",
      "华厦置业\n",
      "海天地悦旅\n",
      "沿海家园\n",
      "国电科环\n",
      "开明投资\n",
      "中核国际\n",
      "恒嘉融资租赁\n",
      "林达控股\n",
      "永盛新材料\n",
      "博耳电力\n",
      "中国金融投资管理\n",
      "滨海投资\n",
      "飞鱼科技\n",
      "金山工业\n",
      "兴合控股\n",
      "新丰泰集团\n",
      "TS WONDERS\n",
      "渝太地产\n",
      "慕诗国际\n",
      "HPC HOLDINGS\n",
      "冠忠巴士集团\n",
      "中国三迪\n",
      "首都创投\n",
      "潼关黄金\n",
      "康华医疗\n",
      "顺泰控股\n",
      "中国大冶有色金属\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "加达控股\n",
      "达进东方照明\n",
      "华彩控股\n",
      "WANG ON GROUP\n",
      "皓天财经集团\n",
      "欧化\n",
      "国开国际投资\n",
      "美丽中国控股\n",
      "迪生创建\n",
      "进智公共交通\n",
      "志高控股\n",
      "万裕科技\n",
      "金仑控股有限公司\n",
      "成都高速\n",
      "华鼎控股\n",
      "中国智能健康\n",
      "弘海高新资源\n",
      "时富投资\n",
      "民商创科\n",
      "信达国际控股\n",
      "盈信控股\n",
      "亚洲联网科技\n",
      "御佳控股\n",
      "中国通海金融\n",
      "新福港\n",
      "三和建筑集团\n",
      "巨星医疗控股\n",
      "森信纸业集团\n",
      "宏辉集团\n",
      "自然美\n",
      "丰德丽控股\n",
      "越南制造加工出口\n",
      "海鑫集团\n",
      "MI能源\n",
      "奥克斯国际\n",
      "PLATT NERA\n",
      "中国油气控股\n",
      "丝路物流控股\n",
      "新确科技\n",
      "祈福生活服务\n",
      "能源国际投资\n",
      "华大酒店\n",
      "江苏创新\n",
      "全达电器集团控股\n",
      "金猫银猫\n",
      "中视金桥\n",
      "广南(集团)\n",
      "SINCEREWATCH HK\n",
      "万华媒体\n",
      "金茂源环保\n",
      "永旺\n",
      "信佳国际\n",
      "环能国际\n",
      "佐力小贷\n",
      "世界(集团)\n",
      "绿心集团\n",
      "中国再生能源投资\n",
      "国银租赁\n",
      "惠生国际\n",
      "安贤园中国\n",
      "保发集团\n",
      "华信金融投资\n",
      "中国兴业控股\n",
      "卓珈控股\n",
      "杉杉品牌\n",
      "新华通讯频媒\n",
      "赛晶电力电子\n",
      "香港生力啤\n",
      "亚洲实业集团\n",
      "建业建荣\n",
      "粤海置地\n",
      "迪诺斯环保\n",
      "CNT GROUP\n",
      "成都普天电缆股份\n",
      "济丰包装\n",
      "鳄鱼恤\n",
      "中国置业投资\n",
      "超大现代\n",
      "渖阳公用发展股份\n",
      "中国创新投资\n",
      "中国环保科技\n",
      "玖源集团\n",
      "培力控股\n",
      "TERMBRAY IND\n",
      "顺诚\n",
      "寰宇娱乐文化\n",
      "金马能源\n",
      "广泰国际控股\n",
      "顺龙控股\n",
      "高鹏矿业\n",
      "汉国置业\n",
      "泰坦能源技术\n",
      "宏光照明\n",
      "华津国际控股\n",
      "耀高控股\n",
      "嘉进投资国际\n",
      "兴泸水务\n",
      "中国互联网投资\n",
      "宾仕国际\n",
      "MOS HOUSE\n",
      "中国钱包\n",
      "南岸集团\n",
      "研祥智能\n",
      "中国农林低碳\n",
      "卡姆丹克太阳能\n",
      "实德环球\n",
      "中国新城镇\n",
      "旭日企业\n",
      "中铝国际\n",
      "CHINAPROPERTIES\n",
      "香港食品投资\n",
      "冠均国际控股\n",
      "信盛矿业\n",
      "位元堂\n",
      "中国公共采购\n",
      "美捷汇控股\n",
      "京西国际\n",
      "汇汉控股\n",
      "南戈壁-S\n",
      "豆盟科技\n",
      "闽港控股\n",
      "天德化工\n",
      "蒙古能源\n",
      "雅天妮集团\n",
      "中国水业集团\n",
      "星谦发展\n",
      "北京控股环境集团\n",
      "保集健康\n",
      "励时集团\n",
      "美亚娱乐资讯\n",
      "绿色能源科技集团\n",
      "和嘉控股\n",
      "蜡笔小新食品\n",
      "广州基金国际控股\n",
      "北京京客隆\n",
      "云铜股份\n",
      "大成食品\n",
      "精英汇集团\n",
      "联众\n",
      "卓悦控股\n",
      "裕田中国\n",
      "正大企业国际\n",
      "金粤控股\n",
      "泰山石化\n",
      "中富资源\n",
      "华昱高速\n",
      "万顺集团控股\n",
      "综合环保集团\n",
      "京维集团\n",
      "景福集团\n",
      "永丰集团控股\n",
      "SINO HOTELS\n",
      "富士高实业\n",
      "海蓝控股\n",
      "先机企业集团\n",
      "朗生医药\n",
      "霸王集团\n",
      "前海健康\n",
      "合丰集团\n",
      "亚证地产\n",
      "中国汽车内饰\n",
      "合一投资\n",
      "精优药业\n",
      "富元国际集团\n",
      "勒泰集团\n",
      "中国金融国际\n",
      "西王置业\n",
      "世纪睿科\n",
      "衍生集团\n",
      "中国铁钛\n",
      "十方控股\n",
      "中建富通\n",
      "权威金融\n",
      "羚邦集团\n",
      "万景控股\n",
      "五龙动力\n",
      "中国海外诺信\n",
      "意科控股\n",
      "进阶发展\n",
      "中国玻璃\n",
      "通达宏泰\n",
      "晨讯科技\n",
      "中国集成控股\n",
      "MATRIX HOLDINGS\n",
      "未来发展控股\n",
      "满地科技股份\n",
      "大同机械\n",
      "叙福楼集团\n",
      "安全货仓\n",
      "万事昌国际\n",
      "云能国际\n",
      "新矿资源\n",
      "香港通讯国际控股\n",
      "星光集团\n",
      "中国数码信息\n",
      "新天地产集团\n",
      "力宝华润\n",
      "普星洁能\n",
      "益华控股\n",
      "华荣能源\n",
      "强泰环保\n",
      "万嘉集团\n",
      "奥邦建筑\n",
      "高富集团控股\n",
      "工盖有限公司\n",
      "HKE HOLDINGS\n",
      "瑞威资管\n",
      "金宝通\n",
      "高丰集团控股\n",
      "川河集团\n",
      "创美药业\n",
      "香港华人有限公司\n",
      "现恒建筑\n",
      "俊裕地基\n",
      "天洁环境\n",
      "NIRAKU\n",
      "中国新城市\n",
      "粤海制革\n",
      "怡邦行控股\n",
      "庄园牧场\n",
      "三宝科技\n",
      "光丽科技\n",
      "中国医疗网络\n",
      "同方友友\n",
      "幸福控股\n",
      "中国城市基础设施\n",
      "中国顺客隆\n",
      "长兴国际\n",
      "贵联控股\n",
      "黛丽斯国际\n",
      "实力建业\n",
      "巨匠建设\n",
      "美联工商铺\n",
      "隽泰控股\n",
      "瑞鑫国际集团\n",
      "建德国际控股\n",
      "中国投融资\n",
      "大成糖业\n",
      "建成控股\n",
      "金力集团\n",
      "大洋集团\n",
      "奥威控股\n",
      "联亚集团\n",
      "永恒策略\n",
      "鼎立资本\n",
      "黄河实业\n",
      "中国淀粉\n",
      "建联集团\n",
      "恒都集团\n",
      "兴证国际\n",
      "大昌微线集团\n",
      "泰加保险\n",
      "玮俊生物科技\n",
      "BHCC HOLDING\n",
      "光大永年\n",
      "星美文化旅游\n",
      "国际商业结算\n",
      "毅兴行\n",
      "大湾区投资控股\n",
      "庄士机构国际\n",
      "中国唐商\n",
      "中国华星\n",
      "汉思能源\n",
      "中星集团控股\n",
      "米兰站\n",
      "凯知乐国际\n",
      "双桦控股\n",
      "中国基建投资\n",
      "中科生物\n",
      "先丰服务集团\n",
      "中绿\n",
      "百利保控股\n",
      "冠中地产\n",
      "大同集团\n",
      "融信资源\n",
      "永义国际\n",
      "天成国际\n",
      "<class 'tuple'>\n",
      "<class 'tuple'>\n",
      "<class 'tuple'>\n",
      "<class 'tuple'>\n",
      "<class 'tuple'>\n",
      "['腾讯控股', '康希诺生物-B', '中华汽车', '保利物业', '阿里巴巴-SW'] [12.2, 10.0, 9.8, 7.85, 6.8]\n"
     ]
    }
   ],
   "source": [
    "ff = {}\n",
    "for i in a1[\"股票名称\"]:\n",
    "    try:\n",
    "        f1 = a1[a1[\"股票名称\"]== i]\n",
    "        f2 = a2[a2[\"股票名称\"]== i]\n",
    "        f3 = a3[a3[\"股票名称\"]== i]\n",
    "        f4 = a4[a4[\"股票名称\"]== i]\n",
    "        f5 = a5[a5[\"股票名称\"]== i]\n",
    "        print(i)\n",
    "        ee = float(f1['涨跌额'].values[0])+float(f2['涨跌额'].values[0])+float(f3['涨跌额'].values[0])+float(f4['涨跌额'].values[0])+float(f5['涨跌额'].values[0])\n",
    "        #data = map(eval, data) \n",
    "        #print(llll)\n",
    "        ff[i] = ee\n",
    "    except:\n",
    "        ff[i] = ee\n",
    "\n",
    "list_result = sorted(zip(ff.values(),ff.keys()),reverse=True)\n",
    "gg = list_result[:5]\n",
    "kk=[]\n",
    "vv=[]\n",
    "for i in gg:\n",
    "    print(type(i))\n",
    "    kk.append(i[1])\n",
    "    vv.append(i[0])\n",
    "    \n",
    "print(kk,vv)\n",
    "\n",
    "#     a1[\"平均\"] = (f1+f2+f3+f4+f5)/5\n",
    "    #a1[a1[\"销售额\"]>2000000].sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"7c7cadee8c274a8688bcbeec6ba0058f\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_7c7cadee8c274a8688bcbeec6ba0058f = echarts.init(document.getElementById('7c7cadee8c274a8688bcbeec6ba0058f'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_7c7cadee8c274a8688bcbeec6ba0058f = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5e73\\u5747\\u989d\\u5ea6\\u6700\\u9ad8\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 461701,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u6da8\\u8dcc\\u989d\",\n",
       "            \"data\": [\n",
       "                12.2,\n",
       "                10.0,\n",
       "                9.8,\n",
       "                7.85,\n",
       "                6.8\n",
       "            ],\n",
       "            \"barCategoryGap\": \"40%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 461701\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u6da8\\u8dcc\\u989d\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u817e\\u8baf\\u63a7\\u80a1\",\n",
       "                \"\\u5eb7\\u5e0c\\u8bfa\\u751f\\u7269-B\",\n",
       "                \"\\u4e2d\\u534e\\u6c7d\\u8f66\",\n",
       "                \"\\u4fdd\\u5229\\u7269\\u4e1a\",\n",
       "                \"\\u963f\\u91cc\\u5df4\\u5df4-SW\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_7c7cadee8c274a8688bcbeec6ba0058f.setOption(option_7c7cadee8c274a8688bcbeec6ba0058f);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.bar.Bar at 0x7fbd65fce990>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#柱形图表示前五名\n",
    "\n",
    "bar=Bar(\"平均涨跌额最高\")\n",
    "#bar.add(\"韩城\",attr,v2,is_stack=True) 可以叠加\n",
    "bar.add(\"涨跌额\",kk,vv,bar_category_gap=\"40%\",mkar_point=[\"average\"])#平均值\n",
    "#bar.add(\"韩城\",attr,v2,bar_category_gap=\"40%\",mkrk_point=[\"min\",\"max\"])#俩个块之间的距离"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>股票编号</th>\n",
       "      <th>股票名称</th>\n",
       "      <th>最新价</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>今开</th>\n",
       "      <th>最高</th>\n",
       "      <th>最低</th>\n",
       "      <th>昨收</th>\n",
       "      <th>今交</th>\n",
       "      <th>成交额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1180</td>\n",
       "      <td>784</td>\n",
       "      <td>凌锐控股</td>\n",
       "      <td>2.18</td>\n",
       "      <td>0.01</td>\n",
       "      <td>257.38</td>\n",
       "      <td>2.19</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.14</td>\n",
       "      <td>2.17</td>\n",
       "      <td>460000</td>\n",
       "      <td>998500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>804</td>\n",
       "      <td>8</td>\n",
       "      <td>电讯盈科</td>\n",
       "      <td>4.71</td>\n",
       "      <td>0.02</td>\n",
       "      <td>7.05</td>\n",
       "      <td>4.68</td>\n",
       "      <td>4.71</td>\n",
       "      <td>4.68</td>\n",
       "      <td>4.69</td>\n",
       "      <td>2123295</td>\n",
       "      <td>9981323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>805</td>\n",
       "      <td>1310</td>\n",
       "      <td>香港宽频</td>\n",
       "      <td>13.06</td>\n",
       "      <td>0.16</td>\n",
       "      <td>-6.98</td>\n",
       "      <td>13.02</td>\n",
       "      <td>13.08</td>\n",
       "      <td>12.88</td>\n",
       "      <td>12.9</td>\n",
       "      <td>765500</td>\n",
       "      <td>9945660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>806</td>\n",
       "      <td>2038</td>\n",
       "      <td>富智康集团</td>\n",
       "      <td>1.54</td>\n",
       "      <td>0.01</td>\n",
       "      <td>58.76</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1.55</td>\n",
       "      <td>1.51</td>\n",
       "      <td>1.53</td>\n",
       "      <td>6478724</td>\n",
       "      <td>9941496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>577</td>\n",
       "      <td>2313</td>\n",
       "      <td>申洲国际</td>\n",
       "      <td>110</td>\n",
       "      <td>0.5</td>\n",
       "      <td>7.11</td>\n",
       "      <td>108</td>\n",
       "      <td>110</td>\n",
       "      <td>108</td>\n",
       "      <td>109.5</td>\n",
       "      <td>906201</td>\n",
       "      <td>99233293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>329</td>\n",
       "      <td>1332</td>\n",
       "      <td>中国透云</td>\n",
       "      <td>0.212</td>\n",
       "      <td>0</td>\n",
       "      <td>-28.14</td>\n",
       "      <td>0.212</td>\n",
       "      <td>0.212</td>\n",
       "      <td>0.212</td>\n",
       "      <td>0.212</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>328</td>\n",
       "      <td>1329</td>\n",
       "      <td>首创钜大</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.19</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>327</td>\n",
       "      <td>1328</td>\n",
       "      <td>金涌投资</td>\n",
       "      <td>0.094</td>\n",
       "      <td>0</td>\n",
       "      <td>-23.58</td>\n",
       "      <td>0.094</td>\n",
       "      <td>0.094</td>\n",
       "      <td>0.094</td>\n",
       "      <td>0.094</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>326</td>\n",
       "      <td>1322</td>\n",
       "      <td>创达科技控股</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>0.231</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>329</td>\n",
       "      <td>东建国际</td>\n",
       "      <td>0.98</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>-13.27</td>\n",
       "      <td>1.09</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.98</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2091 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      股票编号    股票名称    最新价    涨跌额     涨跌幅     今开     最高     最低     昨收       今交  \\\n",
       "1180   784    凌锐控股   2.18   0.01  257.38   2.19    2.2   2.14   2.17   460000   \n",
       "804      8    电讯盈科   4.71   0.02    7.05   4.68   4.71   4.68   4.69  2123295   \n",
       "805   1310    香港宽频  13.06   0.16   -6.98  13.02  13.08  12.88   12.9   765500   \n",
       "806   2038   富智康集团   1.54   0.01   58.76   1.54   1.55   1.51   1.53  6478724   \n",
       "577   2313    申洲国际    110    0.5    7.11    108    110    108  109.5   906201   \n",
       "...    ...     ...    ...    ...     ...    ...    ...    ...    ...      ...   \n",
       "329   1332    中国透云  0.212      0  -28.14  0.212  0.212  0.212  0.212        0   \n",
       "328   1329    首创钜大   0.97      0  -10.19   0.97   0.97   0.97   0.97        0   \n",
       "327   1328    金涌投资  0.094      0  -23.58  0.094  0.094  0.094  0.094        0   \n",
       "326   1322  创达科技控股      -      -       -      -      -      -  0.231        -   \n",
       "0      329    东建国际   0.98  -0.11  -13.27   1.09   1.09   0.98   1.09        0   \n",
       "\n",
       "           成交额  \n",
       "1180    998500  \n",
       "804    9981323  \n",
       "805    9945660  \n",
       "806    9941496  \n",
       "577   99233293  \n",
       "...        ...  \n",
       "329          -  \n",
       "328          -  \n",
       "327          -  \n",
       "326          -  \n",
       "0            -  \n",
       "\n",
       "[2091 rows x 11 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 数据使用\n",
    "\n",
    "#df_mean=db1.sort_values(\"成交额\",ascending=False)#降序#0是行 1 是列\n",
    "#df_mean=db2.sort_values(\"成交额\",ascending=False)#降序#0是行 1 是列\n",
    "df_mean=db2.sort_values(\"成交额\",ascending=False)#降序#0是行 1 是列\n",
    "df_mean\n",
    "#db1.loc[0:3,[\"股票编号\",\"今交\",\"成交额\"]]\n",
    "# # 绘制图表\n",
    "# fig, ax = plt.subplots(figsize=(14,8)) # 绘图窗口大小\n",
    "# plt.title('2017年苹果股票', fontsize=18)  # 标题\n",
    "# # 绘制参考线\n",
    "# (bdata['close']-bdata['open']).plot(grid=True, color='red', label='每日涨跌(收盘价-开盘价)').axhline(y=0, color='black', lw=2)\n",
    "# ax.legend(frameon=False)\n",
    "# plt.xlabel('1-12月份', fontsize=14)   # 横坐标\n",
    "# plt.ylabel('涨跌幅度', fontsize=14) #纵坐标\n",
    "# # 刻度标记大小\n",
    "# # axis 可选择参数 x,y,both \n",
    "# plt.tick_params(axis='both',labelsize=13) \n",
    "# plt.show() # 显示"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "工业零件及器材 80\n",
      "地产发展商 158\n",
      "证券及经纪 47\n",
      "楼宇建造 95\n",
      "软件开发 33\n",
      "电讯设备 38\n",
      "银行 51\n",
      "药品 61\n",
      "信贷 45\n",
      "地产投资 67\n",
      "投资及资产管理 46\n",
      "系统开发及资讯科技顾问 32\n",
      "服装 62\n",
      "重型基建 34\n",
      "['工业零件及器材', '地产发展商', '证券及经纪', '楼宇建造', '软件开发', '电讯设备', '银行', '药品', '信贷', '地产投资', '投资及资产管理', '系统开发及资讯科技顾问', '服装', '重型基建'] [80, 158, 47, 95, 33, 38, 51, 61, 45, 67, 46, 32, 62, 34]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"5e87479b820c4f8b9d86853edac5116d\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_5e87479b820c4f8b9d86853edac5116d = echarts.init(document.getElementById('5e87479b820c4f8b9d86853edac5116d'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_5e87479b820c4f8b9d86853edac5116d = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u6e2f\\u80a1\\u5927\\u4e8e\\u4e09\\u5341\\u5bb6\\u7684\\u4ea7\\u4e1a\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 3598545,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u5de5\\u4e1a\\u96f6\\u4ef6\\u53ca\\u5668\\u6750\",\n",
       "                    \"value\": 80\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5730\\u4ea7\\u53d1\\u5c55\\u5546\",\n",
       "                    \"value\": 158\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8bc1\\u5238\\u53ca\\u7ecf\\u7eaa\",\n",
       "                    \"value\": 47\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u697c\\u5b87\\u5efa\\u9020\",\n",
       "                    \"value\": 95\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8f6f\\u4ef6\\u5f00\\u53d1\",\n",
       "                    \"value\": 33\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7535\\u8baf\\u8bbe\\u5907\",\n",
       "                    \"value\": 38\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u94f6\\u884c\",\n",
       "                    \"value\": 51\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u836f\\u54c1\",\n",
       "                    \"value\": 61\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4fe1\\u8d37\",\n",
       "                    \"value\": 45\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5730\\u4ea7\\u6295\\u8d44\",\n",
       "                    \"value\": 67\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6295\\u8d44\\u53ca\\u8d44\\u4ea7\\u7ba1\\u7406\",\n",
       "                    \"value\": 46\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7cfb\\u7edf\\u5f00\\u53d1\\u53ca\\u8d44\\u8baf\\u79d1\\u6280\\u987e\\u95ee\",\n",
       "                    \"value\": 32\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u670d\\u88c5\",\n",
       "                    \"value\": 62\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u91cd\\u578b\\u57fa\\u5efa\",\n",
       "                    \"value\": 34\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 3598545\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5de5\\u4e1a\\u96f6\\u4ef6\\u53ca\\u5668\\u6750\",\n",
       "                \"\\u5730\\u4ea7\\u53d1\\u5c55\\u5546\",\n",
       "                \"\\u8bc1\\u5238\\u53ca\\u7ecf\\u7eaa\",\n",
       "                \"\\u697c\\u5b87\\u5efa\\u9020\",\n",
       "                \"\\u8f6f\\u4ef6\\u5f00\\u53d1\",\n",
       "                \"\\u7535\\u8baf\\u8bbe\\u5907\",\n",
       "                \"\\u94f6\\u884c\",\n",
       "                \"\\u836f\\u54c1\",\n",
       "                \"\\u4fe1\\u8d37\",\n",
       "                \"\\u5730\\u4ea7\\u6295\\u8d44\",\n",
       "                \"\\u6295\\u8d44\\u53ca\\u8d44\\u4ea7\\u7ba1\\u7406\",\n",
       "                \"\\u7cfb\\u7edf\\u5f00\\u53d1\\u53ca\\u8d44\\u8baf\\u79d1\\u6280\\u987e\\u95ee\",\n",
       "                \"\\u670d\\u88c5\",\n",
       "                \"\\u91cd\\u578b\\u57fa\\u5efa\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_5e87479b820c4f8b9d86853edac5116d.setOption(option_5e87479b820c4f8b9d86853edac5116d);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.pie.Pie at 0x7f7d4c3a1890>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#数据种类\n",
    "import pyecharts\n",
    "df = pd.read_csv(\"zhanglong2.csv\")\n",
    "aa= []\n",
    "for i in df[\"产业种类\"]:\n",
    "    aa.append(i)\n",
    "\n",
    "a = {}\n",
    "#数组叠加内元素\n",
    "for i in aa:\n",
    "    if aa.count(i)>1:\n",
    "        a[i] = aa.count(i)\n",
    "#print(a)\n",
    "name =[]\n",
    "values=[]\n",
    "for key,value in a.items():\n",
    "    if value > 30:\n",
    "        print(key,value)\n",
    "        name.append(key)\n",
    "        values.append(value)\n",
    "print(name,values)\n",
    "pie=pyecharts.Pie(\"港股大于三十家的产业\")\n",
    "pie.add(\"\",name,values)\n",
    "#pie.render()\n",
    "# group = df[\"市盈率\"].groupby([df[\"产业种类\"],df[\"公司\"]])#分组查看\n",
    "# group.mean()\n",
    "\n",
    "# df_mean=hangye.drop([\"股票编号\",\"公司\"],axis=1).groupby(\"产业种类\").mean().sort_values(\"市盈率\",ascending=False)#降序#0是行 1 是列\n",
    "# df_mean\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>股票编号</th>\n",
       "      <th>公司</th>\n",
       "      <th>市盈率</th>\n",
       "      <th>产业种类</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>667</td>\n",
       "      <td>668</td>\n",
       "      <td>241</td>\n",
       "      <td>中信21世纪有限公司</td>\n",
       "      <td>-93983.702760</td>\n",
       "      <td>药品</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>946</td>\n",
       "      <td>947</td>\n",
       "      <td>974</td>\n",
       "      <td>中国顺客隆控股有限公司</td>\n",
       "      <td>-1391.025891</td>\n",
       "      <td>多元化零售商</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>720</td>\n",
       "      <td>721</td>\n",
       "      <td>42</td>\n",
       "      <td>东北电气发展股份有限公司</td>\n",
       "      <td>-790.687539</td>\n",
       "      <td>工业零件及器材</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>486</td>\n",
       "      <td>487</td>\n",
       "      <td>784</td>\n",
       "      <td>凌锐控股有限公司</td>\n",
       "      <td>-671.875000</td>\n",
       "      <td>楼宇建造</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>225</td>\n",
       "      <td>226</td>\n",
       "      <td>1707</td>\n",
       "      <td>致浩达控股有限公司</td>\n",
       "      <td>-569.491525</td>\n",
       "      <td>重型基建</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>873</td>\n",
       "      <td>874</td>\n",
       "      <td>612</td>\n",
       "      <td>中国投资基金有限公司</td>\n",
       "      <td>-551.289555</td>\n",
       "      <td>投资及资产管理</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>376</td>\n",
       "      <td>377</td>\n",
       "      <td>726</td>\n",
       "      <td>东南国际集团有限公司</td>\n",
       "      <td>-426.257760</td>\n",
       "      <td>地产发展商</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>283</td>\n",
       "      <td>284</td>\n",
       "      <td>286</td>\n",
       "      <td>金匡企业有限公司</td>\n",
       "      <td>-425.793487</td>\n",
       "      <td>医疗及医学美容服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>615</td>\n",
       "      <td>616</td>\n",
       "      <td>1003</td>\n",
       "      <td>21控股有限公司</td>\n",
       "      <td>-393.205556</td>\n",
       "      <td>影视娱乐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1158</td>\n",
       "      <td>1159</td>\n",
       "      <td>2239</td>\n",
       "      <td>国微控股有限公司</td>\n",
       "      <td>-392.603271</td>\n",
       "      <td>电讯设备</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  股票编号            公司           市盈率       产业种类\n",
       "667    668   241    中信21世纪有限公司 -93983.702760         药品\n",
       "946    947   974   中国顺客隆控股有限公司  -1391.025891     多元化零售商\n",
       "720    721    42  东北电气发展股份有限公司   -790.687539    工业零件及器材\n",
       "486    487   784      凌锐控股有限公司   -671.875000       楼宇建造\n",
       "225    226  1707     致浩达控股有限公司   -569.491525       重型基建\n",
       "873    874   612    中国投资基金有限公司   -551.289555    投资及资产管理\n",
       "376    377   726    东南国际集团有限公司   -426.257760      地产发展商\n",
       "283    284   286      金匡企业有限公司   -425.793487  医疗及医学美容服务\n",
       "615    616  1003      21控股有限公司   -393.205556       影视娱乐\n",
       "1158  1159  2239      国微控股有限公司   -392.603271       电讯设备"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 营业率前十名的分析\n",
    "df = pd.read_csv(\"zhanglong2.csv\")\n",
    "df.head()\n",
    "df_mean=df.sort_values(\"市盈率\",ascending=True)#降序#0是行 1 是列\n",
    "df_mean[0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
